﻿CREATE TABLE [dbo].[dscGateway_StorageSCP] (
    [StorageSCPID] INT           IDENTITY (1, 1) NOT NULL,
    [Location]     VARCHAR (250) NOT NULL,
    [Bitbucket]    BIT           DEFAULT ((0)) NOT NULL,
    [List]         BIT           DEFAULT ((0)) NOT NULL,
    [JpegLossless] BIT           DEFAULT ((0)) NOT NULL,
    [JpegLoss]     BIT           DEFAULT ((0)) NOT NULL,
    [Rle]          BIT           DEFAULT ((0)) NOT NULL,
    [J2KLossless]  BIT           DEFAULT ((0)) NOT NULL,
    [J2KLoss]      BIT           DEFAULT ((0)) NOT NULL,
    [Port]         INT           DEFAULT ((0)) NOT NULL,
    [AETitle]      VARCHAR (100) DEFAULT ('') NOT NULL,
    CONSTRAINT [PK_dscGateway_StorageSCP] PRIMARY KEY CLUSTERED ([StorageSCPID] ASC)
);

